from sqlalchemy import Column, Integer, String, Date
from app.database import Base

class Teacher(Base):
    __tablename__ = "teachers"

    id = Column(Integer, primary_key=True, index=True)
    name = Column(String(50), index=True)
    email = Column(String(100), unique=True, index=True)
    department = Column(String(100))
    date_of_birth = Column(Date)
    hire_date = Column(Date)  # 入职日期